<?php
$listARF85->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));

$listARF85ERDF->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));

$listPosteDP->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));

$listCS06->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));

$listC06->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));

$listFIPPoste->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));

$listFIPLigne1->execute(array(
    'type_etude' => "municipalite",
    'id_etude' => $_SESSION['id_etude']
));
?>

<table>
    <caption> R&eacute;capitulatif des conventions </caption>

    <tr>
        <th colspan="2"> Convention ARF85 </th>
    </tr>
    <?php
    while ($ARF85 = $listARF85->fetch()) {
        ?>
        <tr>
            <td> <?php echo $ARF85['date']; ?> </td>  
            <td> <a href="conventionARF85.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $ARF85['id_convention_arf85']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /> </a></td>
        </tr>
    <?php } ?>
</tr>
<tr>
    <th colspan="2"> Convention ARF85 ERDF </th>
</tr>
<?php
while ($ARF85ERDF = $listARF85ERDF->fetch()) {
    ?>
    <tr>
        <td> <?php echo $ARF85ERDF['date']; ?> </td>
        <td> <a href="conventionARF85ERDF.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $ARF85ERDF['id_convention_arf85_erdf']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /></a> </td>
    </tr>
<?php } ?>
<tr>
    <th colspan="2"> Convention Poste DP </th>
</tr>
<?php
while ($PosteDP = $listPosteDP->fetch()) {
    ?>
    <tr>
        <td> <?php echo $PosteDP['id_convention_poste']; ?> </td>
        <td> <a href="conventionPosteDP.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $PosteDP['id_convention_poste']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /></a> </td>
    </tr>
<?php } ?>
<tr>
    <th colspan="2"> Convention CS06 </th>
</tr>
<?php
while ($CS06 = $listCS06->fetch()) {
    ?>
    <tr>
        <td> <?php echo $CS06['id_convention_cs06']; ?> </td>
        <td> <a href="conventionCS06.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $CS06['id_convention_cs06']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /></a> </td>
    </tr>
<?php } ?>
<tr>
    <th colspan="2"> Convention C06 </th>
</tr>
<?php
while ($C06 = $listC06->fetch()) {
    ?>
    <tr>
        <td> <?php echo $C06['id_convention_c06']; ?> </td>
        <td> <a href="conventionC06.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $C06['id_convention_c06']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /></a> </td>
    </tr>
<?php } ?>
<tr>
    <th colspan="2"> Convention FIP Poste </th>
</tr>
<?php
while ($FIPPoste = $listFIPPoste->fetch()) {
    ?>
    <tr>
        <td> <?php echo $FIPPoste['id_convention_fipposte']; ?> </td>
        <td> <a href="conventionFIPPoste.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $FIPPoste['id_convention_fipposte']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /></a> </td>
    </tr>
<?php } ?>
<tr>
    <th colspan="2"> Convention FIP Ligne1 </th>
</tr>
<?php
while ($FIPListe1 = $listFIPLigne1->fetch()) {
    ?>
    <tr>
        <td> <?php echo $FIPListe1['id_convention_fipligne1']; ?> </td>
        <td> <a href="conventionFIPLigne1.php?typeEtude=municipalite&idEtude=<?php echo $_SESSION['id_etude']; ?>&idConvention=<?php echo $FIPListe1['id_convention_fipligne1']; ?>" TARGET=_BLANK><input type="button" value="Générer PDF" /></a> </td>
    </tr>
<?php } ?>


</table>
